
INSERT INTO [ExpoDatabases].[dbo].[BoothInformation]
           ([id]
           ,[name]
           ,[space]
           ,[spaceUnitMeasureID]
           ,[fees]
           ,[sponsor]
           ,[exhibitorID]
           ,[contractCode]
           ,[status]
           ,[registerDate]
           ,[lastDate]
           ,[modifiedDate])
     VALUES
           (1
           ,'da01'
           ,20
           ,1
           ,2000
           ,'microsoft'
           ,7
           ,111
           ,0
           ,'1/21/2011 12:00:00 AM'
           ,'1/23/2011 12:00:00 AM'
           ,'1/22/2011 12:00:00 AM')
go

INSERT INTO [ExpoDatabases].[dbo].[BoothInformation]
           ([id]
           ,[name]
           ,[space]
           ,[spaceUnitMeasureID]
           ,[fees]
           ,[sponsor]
           ,[exhibitorID]
           ,[contractCode]
           ,[status]
           ,[registerDate]
           ,[lastDate]
           ,[modifiedDate])
     VALUES
           (2
           ,'da02'
           ,20
           ,2
           ,3000
           ,'nokia'
           ,7
           ,1112
           ,1
           ,'1/21/2011 12:00:00 AM'
           ,'1/23/2011 12:00:00 AM'
           ,'1/22/2011 12:00:00 AM')
go


INSERT INTO [ExpoDatabases].[dbo].[BoothInformation]
           ([id]
           ,[name]
           ,[space]
           ,[spaceUnitMeasureID]
           ,[fees]
           ,[sponsor]
           ,[exhibitorID]
           ,[contractCode]
           ,[status]
           ,[registerDate]
           ,[lastDate]
           ,[modifiedDate])
     VALUES
           (3
           ,'da03'
           ,20
           ,3
           ,2500
           ,'Del'
           ,7
           ,1112
           ,1
           ,'1/21/2011 12:00:00 AM'
           ,'1/23/2011 12:00:00 AM'
           ,'1/22/2011 12:00:00 AM')
go

INSERT INTO [ExpoDatabases].[dbo].[BoothProduct]
           ([name]
           ,[cost]
           ,[size]
           ,[weight]
           ,[Description]
           ,[categoryID]
           ,[boothID]
           ,[weightUnitMeasureID]
           ,[sizeUnitMeasureID]
           ,[modifiedDate]
           ,[status])
     VALUES
           ('TVSony'
           ,300
           ,24
           ,2
           ,'For life'
           ,1
           ,1
           ,1
           ,1
           ,'1/21/2011 12:00:00 AM'
           ,1)
go
INSERT INTO [ExpoDatabases].[dbo].[BoothProduct]
           ([name]
           ,[cost]
           ,[size]
           ,[weight]
           ,[Description]
           ,[categoryID]
           ,[boothID]
           ,[weightUnitMeasureID]
           ,[sizeUnitMeasureID]
           ,[modifiedDate]
           ,[status])
     VALUES
           ('TVLG'
           ,200
           ,24
           ,2
           ,'Entertaiment'
           ,1
           ,1
           ,1
           ,1
           ,'1/21/2011 12:00:00 AM'
           ,1)
go

INSERT INTO [ExpoDatabases].[dbo].[BoothProduct]
           ([name]
           ,[cost]
           ,[size]
           ,[weight]
           ,[Description]
           ,[categoryID]
           ,[boothID]
           ,[weightUnitMeasureID]
           ,[sizeUnitMeasureID]
           ,[modifiedDate]
           ,[status])
     VALUES
           ('TVSamsung'
           ,250
           ,24
           ,2
           ,'Entertaiment'
           ,2
           ,2
           ,1
           ,1
           ,'1/21/2011 12:00:00 AM'
           ,1)
go

INSERT INTO [ExpoDatabases].[dbo].[Exhibitor]
           ([firstName]
           ,[lastName]
           ,[sex]
           ,[email]
           ,[phone]
           ,[organizationName]
           ,[address]
           ,[city]
           ,[country]
           ,[accountBank]
           ,[bankName]
           ,[status]
           ,[identityCardNumber]
           ,[modifiedDate]
           ,[registerDate])
     VALUES
           ('David'
           ,'Beckham'
           ,'Male'
           ,'a@a.com'
           ,111111
           ,'OZ'
           ,'CO.UK'
           ,'London'
           ,'UK'
           ,'1123-1111-2345-1111'
           ,'WU'
           ,0
           ,123456
           ,'1/1/2011 12:00:00 AM'
           ,'2/4/2011 12:00:00 AM')

go

INSERT INTO [ExpoDatabases].[dbo].[Exhibitor]
           ([firstName]
           ,[lastName]
           ,[sex]
           ,[email]
           ,[phone]
           ,[organizationName]
           ,[address]
           ,[city]
           ,[country]
           ,[accountBank]
           ,[bankName]
           ,[status]
           ,[identityCardNumber]
           ,[modifiedDate]
           ,[registerDate])
     VALUES
           ('Jessica'
           ,'Abba'
           ,'Female'
           ,'abba@ab.com'
           ,11112211
           ,'BL'
           ,'CO.UK'
           ,'London'
           ,'UK'
           ,'2233-2222-2345-1111'
           ,'WU'
           ,0
           ,123456
           ,'1/21/2011 12:00:00 AM'
           ,'2/4/2011 12:00:00 AM')

go




INSERT INTO [ExpoDatabases].[dbo].[ProductCategory]
           ([title])
     VALUES
           ('nice monitor TV')
go
INSERT INTO [ExpoDatabases].[dbo].[ProductCategory]
           ([title])
     VALUES
           ('nice monitor Flash TV')
go
INSERT INTO [ExpoDatabases].[dbo].[SizeUnitMeasure]
           ([symbol])
     VALUES
           ('inch')
go
select* from [SpaceUnitMeasure]
go
INSERT INTO [ExpoDatabases].[dbo].[SpaceUnitMeasure]
           ([symbol])
     VALUES
           ('aaa222')
go
INSERT INTO [ExpoDatabases].[dbo].[SpaceUnitMeasure]
           ([symbol])
     VALUES
           ('aaa1111')
go

INSERT INTO [ExpoDatabases].[dbo].[SpaceUnitMeasure]
           ([symbol])
     VALUES
           ('bbb1111')
go
INSERT INTO [ExpoDatabases].[dbo].[WeighUnitMeasure]
           ([symbol])
     VALUES
           ('kg')
go
INSERT INTO [ExpoDatabases].[dbo].[WeighUnitMeasure]
           ([symbol])
     VALUES
           ('gam')
go

use ExpoDatabases
go
select* from BoothInformation
go
select* from BoothProduct
go
select* from Exhibitor
go
select* from ProductCategory
go
select* from SizeUnitMeasure
go
select* from [SpaceUnitMeasure]
go
select* from [WeighUnitMeasure]
go
